Labels:book | chat room | crt screen | hakham | monitor | plant | sky OCR: DATABASES 639 ORGANIZING RECORDS How are database records organized? Records can be organized in different ways depending on how people want to use them. For example, cust tomer visiting Vintage Music Shop's Web site will most often view the information in the Albums table by AlbumT Title or ArtistName The inventory manager usually wants the data sorted by quantity in stock so that it is easy to see which albums are overstocked. In contrast, the marketing manager is more interested in the Value field, so that rare and expensive albums can be aggressively marketed No single way organizing the data accommo- dates everyone's needs, but tables can be sorted or indexed in multiple ways. What happens when the data in a table is sorted? Atable's sort order the order in which records are stored on ...
